AdTerm 
Logical Entity Name  AdTerm 
Default Table Name  AdTerm 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AdTerm Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(16)  NO 
 
Descrip    char(35)  NO 
 
SyCampusGrpID    int  NO 
 
StartDate    datetime  YES 
 
EndDate    datetime  YES 
 
AdShiftID    int  NO 
 
ModFlag    char(1)  NO 
 
Active    bit  NO 
 
Userid    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
AdTermID(PK)    int  NO 
 
GlobalExtractTerm    bit  YES 
 
AddDropDate    datetime  YES 
 
StudentRegEndDate    datetime  YES 
 
StudentRegStartDate    datetime  YES 
 
RevenueUnits    numeric(5, 2)  YES 
 
TermOpen    bit  NO 
 
AttendanceRecorded    bit  NO 
 
OpenRegistrationBeginDateTime    datetime  YES 
 
OpenRegistrationEndDateTime    datetime  YES 
 
InternalRegistrationBeginDateTime    datetime  YES 
 
InternalRegistrationEndDateTime    datetime  YES 
 
ChildTermDatesRule    bit  NO 
 
SAPTerm    bit  NO 
 
TermUsage    smallint  NO 
 
LMSSendCourseSectionData    bit  NO 
 
LMSSendCourseSectionDataInitialDone    bit  NO 
 
LMSSendInstructorAssignments    bit  NO 
 
LMSSendInstructorAssignmentsInitialDone    bit  NO 
 
LMSSendStudentRegistrationData    bit  NO 
 
LMSSendStudentRegistrationDataInitialDone    bit  NO 
 
AuditDesignationDeadline    datetime  YES 
 
SaCourseRefundPolicyID    int  YES 
 
CampusLinkAmbassadorLiftTermSuspend    bit  NO 
 
SapCalcDaysAfterTermEnd    int  YES 
 
AllowOnlineUsage    bit  NO 
 
RetainLDA    bit  YES 
 
ScheduleChangesType    char(1)  YES 
 
NoOfDaysToRecalcNotification    int  YES 
 
TermRequiresPrePull    bit  NO 
 
NoOfDaysPriorToTermStartDate    int  YES 
 
NoOfDaysAfterTermStartDate    int  YES 
 
StandardTerm    tinyint  NO 
 
StandardTermType    char(1)  YES 
 
FaAcademicCalendar    smallint  YES 
 
CrmSuppressFlag    bit  NO 
 
adTermGroupID(FK)    int  YES 
 
SummerHeaderOrTrailer    tinyint  NO 
 
Intersession    bit  NO 
 
InstructionalWeeks    int  YES 
 

AdTerm Primary and Unique Keys 
Key Name  Key Type  Keys 
AdTerm_Active_SyCampusGrpId_AdTermId_U_N_IDX  Index  Active, SyCampusGrpID, AdTermID 
AdTerm_TermUsage_SyCampusGrpId_Descrip_Code_AdTermID_StartDate_EndDate_Active_TermOpen_U_N_IDX  Index  TermUsage, SyCampusGrpID, Descrip, Code, AdTermID, StartDate, EndDate, Active, TermOpen 
AdTerm_AdTermID_U_C_IDX  PrimaryKey  AdTermID 

AdTerm Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
adTermGroup  Non-Identifying  Zero or One to Zero or More  FK_adTermadTermGroupId_adTermGroupadTermGroupId      adTermGroupID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdEnrollTermConfirm  Non-Identifying  One To Zero or More  AdEnrollTermConfirm_AdTermId_AdTerm_AdTermId        NO  YES 
AmCollegeTransfer  Non-Identifying  One To Zero or More  FK__AmCollege__AdTer__63DC2D9B        NO  YES 
AdEnrollHonors  Non-Identifying  One To Zero or More  FK_AdEnrollHonors_AdTermID_AdTerm_AdTermID        NO  YES 
AdEnrollRegistration  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdTermID_AdTerm_AdTermID        NO  YES 
AdEnrollRegistrationGroup  Non-Identifying  One To Zero or More  FK_AdEnrollRegistrationGroup_AdTermID_AdTerm_AdTermID        NO  YES 
AdEnrollRegTerm  Non-Identifying  One To Zero or More  fk_AdEnrollRegTerm_AdTermID_AdTerm_AdTermID        NO  YES 
AdEnrollSchedStatusChanges  Non-Identifying  One To Zero or More  FK_AdEnrollSchedStatusChangesParentTermID_AdTermAdTermID        NO  YES 
AdEnrollSchedStatusHistory  Non-Identifying  One To Zero or More  FK_AdEnrollSchedStatusHistory_ParentTermID_AdTerm_AdTermID        NO  YES 
AdEnrollTermRelationship  Non-Identifying  One To Zero or More  FK_AdEnrollTermRelationship_ParentAdTermID_AdTerm_AdTermID        NO  YES 
AdGPAStudent  Non-Identifying  One To Zero or More  FK_AdGPAStudentAdParentTermID_AdTermAdTermID        NO  YES 
AdGPAStudent  Non-Identifying  One To Zero or More  FK_AdGPAStudentAdTermID_AdTermAdTermID        NO  YES 
AdRegistrationGroupTerm  Non-Identifying  One To Zero or More  FK_AdRegistrationGroupTerm_AdTermID_AdTerm_AdTermID        NO  YES 
AdRegistrationLock  Non-Identifying  One To Zero or More  FK_AdRegistrationLockAdTermID_AdTermAdTermID        NO  YES 
AdSapQueue_Detail  Non-Identifying  One To Zero or More  FK_AdSapQueue_Detail_AdTermID_AdTerm_AdTermID        NO  YES 
AdStartTerm  Non-Identifying  One To Zero or More  FK_AdStartTerm_AdTermID_AdTerm_AdTermID        NO  YES 
AdStudentTermSequenceHeader  Non-Identifying  One To Zero or More  FK_AdStudentTermSequenceHeader_AdTermID_AdTerm_AdTermID        NO  YES 
AdTermCampusRelationship  Non-Identifying  One To Zero or More  FK_AdTermCampusRelationship_AdTermID_AdTerm_AdTermID        NO  NO 
adTermExternalMap  Non-Identifying  One To Zero or More  FK_adTermExternalMapadTermId_adTermadTermId        NO  YES 
AdTermOnLineRegistration  Identifying  One To Zero or More  FK_AdTermOnlineRegistration_AdTermID_AdTerm_AdTermID        NO  YES 
AdTermProgramAssociation  Non-Identifying  One To Zero or More  FK_AdTermProgramAssociationAdTermID_AdTermAdTermID        NO  YES 
AdTermRelationship  Non-Identifying  One To Zero or More  FK_AdTermRelationship.ChildAdTermID_AdTerm.AdTermID        NO  YES 
AdTermRelationship  Non-Identifying  One To Zero or More  FK_AdTermRelationship.ParentAdTermID_AdTerm.AdTermID        NO  YES 
adTermRelationshipModifyLog  Non-Identifying  One To Zero or More  FK_adTermRelationshipModifyLog_AddedParentTermID_AdTerm_AdTermID        NO  YES 
adTermRelationshipModifyLog  Non-Identifying  One To Zero or More  FK_adTermRelationshipModifyLog_ChildParentAdTermID_AdTerm_AdTermID        NO  YES 
adTermRelationshipModifyLog  Non-Identifying  One To Zero or More  FK_adTermRelationshipModifyLog_RemovedParentAdTermID_AdTerm_AdTermID        NO  YES 
AdTermSequenceStartDate  Non-Identifying  One To Zero or More  FK_AdTermSequenceStartDate_AdTSStartDateTermID_AdTerm_AdTermID        NO  YES 
AmCollegeTransferAdvance  Non-Identifying  One To Zero or More  FK_AmCollegeTransferAdvance_AdTermID_AdTerm_AdTermID        NO  YES 
AmDeposit  Non-Identifying  One To Zero or More  Fk_AmDeposits_AdTermid_AdTerm_AdTermID        NO  YES 
CmDocumentPermit  Non-Identifying  One To Zero or More  FK_CmDocumentPermitAdTermID_AdTermAdTermID        NO  YES 
FaGlobalExtractChildTerm  Non-Identifying  One To Zero or More  FK_FaGlobalExtractChildTerm_AdTermId_AdTerm_AdTermId        NO  YES 
FaIntersessionTermRegistration  Non-Identifying  One To Zero or More  FK_FaIntersessionTermRegistration_IntersessionTermId_AdTerm_AdTermId        NO  YES 
FaIntersessionTermRegistration  Non-Identifying  One To Zero or More  FK_FaIntersessionTermRegistration_ParentTermId_AdTerm_AdTermId        NO  YES 
FaStudentFundPaymentPeriod  Non-Identifying  One To Zero or More  FK_FaStudentFundPaymentPeriodAdTermId_AdTermAdTermId        NO  YES 
FaTermTrack  Non-Identifying  One To Zero or More  FK_FaTermTrack_AdTermId_AdTerm_FaTermAssociationTrackId        NO  YES 
FaTermTrackProgramAssociation  Non-Identifying  One To Zero or More  FK_FaTermTrackProgramAssociation_AdTermID_AdTerm_AdTermID        NO  YES 
HsRoomMateMatchCriteria  Non-Identifying  One To Zero or More  FK_HsRoomMateMatchCriteria_AdTermID_AdTerm_AdTermID        NO  YES 
HSStudentLeaseChargeSchedule  Non-Identifying  One To Zero or More  FK_HsStudentLeaseChargeSchedule_AdTermID_AdTerm_AdTermID        NO  YES 
HSStudentLeaseHistory  Non-Identifying  One To Zero or More  FK_HSStudentLeaseHistory_AdTermID_AdTerm_AdTermID        NO  YES 
HSStudentLeaseHistory  Non-Identifying  One To Zero or More  FK_HsStudentLeaseHistorySaBillTermID_AdTermAdTermID        NO  YES 
SaAutoBillBatchDetail  Non-Identifying  One To Zero or More  FK_SaAutoBillBatchDetail_AdTermID_AdTerm_AdTermID        NO  YES 
SaBillingStatementBatchStudent  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchStudent_AdTermID_AdTerm_AdTermID        NO  YES 
SaEnrollRevenueChildTerm  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_AdTermID_AdTerm_AdTermID        NO  YES 
SaPendingCharge  Non-Identifying  One To Zero or More  FK_saPendingCharge.AdTermID_AdTerm.AdTermID        NO  YES 
SaPendingChargeCourseAmount  Non-Identifying  One To Zero or More  FK_SaPendingChargeCourseAmount_AdTermID_AdTerm_AdTermID        NO  YES 
SaPendingChargeRecalcLog  Non-Identifying  One To Zero or More  FK_SaPendingChargeRecalcLog_AdTermId_AdTerm_AdTermID        NO  YES 
SaRegBillQueue_Detail  Non-Identifying  One To Zero or More  FK_SaRegBillQueue_Detail_AdTermID_AdTerm_AdTermID        NO  YES 
SaRevenueDetail  Non-Identifying  One To Zero or More  FK_SaRevenueDetail_ChildAdTermID_AdTerm_AdTermID        NO  YES 
SaStudentLedgerTermUpdatesArchive  Non-Identifying  One To Zero or More  FK_SaStudentLedgerTermUpdatesArchive_NewAdTermID_AdTerm_AdTermID        NO  YES 
SaStudSubsidiaryTrans  Non-Identifying  One To Zero or More  Fk_SaStudSubsidiaryTrans_AdTermID_AdTerm_AdTermID        NO  YES 
SaSubsidiaryRefund  Non-Identifying  One To Zero or More  Fk_SaSubsidiaryRefund_AdTermID_AdTerm_AdTermID        NO  YES 
SaTransCourse  Non-Identifying  One To Zero or More  FK_SaTransCourse_AdTermID_AdTerm_AdTermID        NO  YES 
SaTransCourseAmount  Non-Identifying  One To Zero or More  FK_SaTransCourseAmount_AdTermID_AdTerm_AdTermID        NO  YES 
SsAthleticDetail  Non-Identifying  One To Zero or More  FK_SsAthleticDetailAdTermID_AdTermAdTermID        NO  YES 
SsStudentServiceAssociation  Non-Identifying  One To Zero or More  FK_SsStudentServiceAssociation_AdTermID_AdTerm_AdTermID        NO  YES 
SsStudentVeteranDetail  Non-Identifying  One To Zero or More  FK_SsStudentVeteranDetailAdTermID_AdTermAdTermID        NO  YES 
SyIndicatorStudentRelation  Non-Identifying  One To Zero or More  FK_SyIndicatorStudentRelation_AdTermID_AdTerm_AdTermID        NO  YES 
SyStatChange  Non-Identifying  One To Zero or More  FK_SyStatChange_AdTermID_AdTerm_AdTermID        NO  YES 
SyStateReportTermMapping  Non-Identifying  One To Zero or More  FK_SyStateReportTermMapping_AdTermID_AdTerm_AdTermID        NO  YES 

AdTerm Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdTerm_OpenRegistrationBeginDateTime_OpenRegistrationEndDateTime  ([OpenRegistrationBeginDateTime] is null and [OpenRegistrationEndDateTime] is null or [OpenRegistrationBeginDateTime] is not null and [OpenRegistrationEndDateTime] is not null and [OpenRegistrationBeginDateTime] <= [OpenRegistrationEndDateTime]) 
Chk_AdTerm_InternalRegistrationBeginDateTime_InternalRegistrationEndDateTime  ([InternalRegistrationBeginDateTime] is null and [InternalRegistrationEndDateTime] is null or [InternalRegistrationBeginDateTime] is not null and [InternalRegistrationEndDateTime] is not null and [InternalRegistrationBeginDateTime] <= [InternalRegistrationEndDateTime]) 

AdTerm Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

AdTerm Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.Term 
NO       
Physical (Microsoft SQL Server)
dbo.AdTerm 
NO       

AdTerm Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  ClassScheduling 
Logical  CourseRegistration 
Logical  DegreePathway 
Logical  Documents 
Logical  Grades/Attendance 
Logical  LedgerCard_Billing 
Logical  PreviousEd_TransferCredits 
Logical  RefundCalculation 
Logical  SubsidiaryLedger 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

AdTerm Data Movement Rules 
Name  Type  Rule Text/Value